﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Restful_Api.Migrations
{
    public partial class UpdateCompany : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("01734449-d08e-4447-840b-20b53b8a465c"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("02221a93-11e2-4d00-9828-f540955a1cf5"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("31df7d18-ee4c-4720-9b77-1c24f0c6e63d"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("36cfde7f-35a8-4792-98d7-147779c37d43"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("3b53f4c2-d427-4006-b9bd-d77ab568f2b0"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("5f0d4e0f-1e07-46e0-b551-63fc3eca24ce"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("6369ab09-7f98-4d60-a8be-d4e3e12cd9c2"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("81cc449c-3d5f-4363-a3fe-8c774bc690eb"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("8d4e771d-fe72-482d-b30f-99c0f4c1bf59"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("92288368-424c-4304-aa49-9604c0733b70"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("9c3a4eb2-36b4-43ea-af42-e9b845754650"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("a423c03a-c623-46a0-8c8b-bff902285f1d"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("ba097ba1-b139-4a87-9ded-b43d58231f23"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("c94da200-36d9-43ce-8639-f23555503a8d"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("d6ebca99-b540-4c78-9f11-6079e649a665"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("5183c983-e1f0-45f9-b71d-0625de98fff2"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("581c5b45-3ad6-4ece-b04f-247bea17e96e"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("9a0e8cb8-e4c6-4fa3-ac91-3467ab4020bd"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("cd20655e-a363-4805-a4ce-a6cf4b4ae9a2"));

            migrationBuilder.AddColumn<string>(
                name: "Country",
                table: "Companies",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "Industry",
                table: "Companies",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "Product",
                table: "Companies",
                nullable: true);

            migrationBuilder.InsertData(
                table: "Companies",
                columns: new[] { "Id", "Country", "Industry", "Introduction", "Name", "Product" },
                values: new object[,]
                {
                    { new Guid("431701c6-3cf3-41cc-9524-bbd7216544b9"), "美国", "计算机", "微软的公司简介", "微软公司", "微软的产品" },
                    { new Guid("6e494c18-d032-4651-981c-7353b86e023c"), null, null, "桃子的公司简介", "桃子", null },
                    { new Guid("ce327f49-fa70-4c4c-8223-9f656c7953a6"), null, null, "葡萄的公司简介", "葡萄", null },
                    { new Guid("477f8b6e-00c5-400b-94ed-3b075df6fe01"), null, null, "橙子的公司简介", "橙子", null },
                    { new Guid("20d8b32d-3cda-4589-b678-0327de608b8e"), null, null, "香蕉的公司简介", "雪梨", null },
                    { new Guid("b9f007cb-d938-4ef5-94fa-e40c94e88ced"), null, null, "香蕉的公司简介", "香蕉", null },
                    { new Guid("204ce5cf-953b-4a17-95eb-f46cfb1da2f1"), null, null, "Vivo的公司简介", "Vivo", null },
                    { new Guid("88fecc1b-e129-4577-b254-c361e0b24654"), null, null, "苹果的公司简介", "苹果", null },
                    { new Guid("5b70788d-a86f-45ae-a94f-7f5d80b8a0ae"), null, null, "魅族的公司简介", "魅族", null },
                    { new Guid("79f77f1c-eb9e-4e96-bd9b-d62d68e67df4"), null, null, "三星的公司简介", "三星", null },
                    { new Guid("df2d5ab1-1320-49d4-b1c1-30f5bb17f161"), null, null, "小米的公司简介", "小米", null },
                    { new Guid("82528380-459b-48a2-b935-36aaf2ff44ea"), "中国", "手机", "HuaWei的公司简介", "华为", "华为的产品" },
                    { new Guid("adcd7517-d1ab-497a-9fce-1268744ef755"), "中国", "直播", "BiliBili的公司简介", "BiliBili", "bili的产品" },
                    { new Guid("1d1e286c-bec0-48b2-9c8f-34cd32f83550"), "中国", "浏览器", "谷歌的公司简介", "Google", "谷歌的产品" },
                    { new Guid("06634c94-9672-4f25-acff-f0d99183e9d9"), null, null, "oppo的公司简介", "oppo", null }
                });

            migrationBuilder.InsertData(
                table: "Employees",
                columns: new[] { "Id", "CompanyId", "DateOfBirth", "EmployeeNo", "FistName", "Gender", "LastName" },
                values: new object[,]
                {
                    { new Guid("2e81ff97-2f00-4232-9027-1a5f3540ed4d"), new Guid("adcd7517-d1ab-497a-9fce-1268744ef755"), new DateTime(2020, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "小", 2, "Lu" },
                    { new Guid("3e2325ed-32e1-41e3-9f8e-9373c8021bb1"), new Guid("431701c6-3cf3-41cc-9524-bbd7216544b9"), new DateTime(2020, 8, 10, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "张", 1, "三" },
                    { new Guid("11699bce-340a-4be5-9609-c676b1f3d8ad"), new Guid("431701c6-3cf3-41cc-9524-bbd7216544b9"), new DateTime(2020, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "李", 1, "四" },
                    { new Guid("7a5dc5a3-35db-48d5-91b7-ae7fd611bd0f"), new Guid("1d1e286c-bec0-48b2-9c8f-34cd32f83550"), new DateTime(2020, 8, 29, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "小", 1, "江" }
                });
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("06634c94-9672-4f25-acff-f0d99183e9d9"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("1d1e286c-bec0-48b2-9c8f-34cd32f83550"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("204ce5cf-953b-4a17-95eb-f46cfb1da2f1"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("20d8b32d-3cda-4589-b678-0327de608b8e"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("431701c6-3cf3-41cc-9524-bbd7216544b9"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("477f8b6e-00c5-400b-94ed-3b075df6fe01"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("5b70788d-a86f-45ae-a94f-7f5d80b8a0ae"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("6e494c18-d032-4651-981c-7353b86e023c"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("79f77f1c-eb9e-4e96-bd9b-d62d68e67df4"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("82528380-459b-48a2-b935-36aaf2ff44ea"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("88fecc1b-e129-4577-b254-c361e0b24654"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("adcd7517-d1ab-497a-9fce-1268744ef755"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("b9f007cb-d938-4ef5-94fa-e40c94e88ced"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("ce327f49-fa70-4c4c-8223-9f656c7953a6"));

            migrationBuilder.DeleteData(
                table: "Companies",
                keyColumn: "Id",
                keyValue: new Guid("df2d5ab1-1320-49d4-b1c1-30f5bb17f161"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("11699bce-340a-4be5-9609-c676b1f3d8ad"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("2e81ff97-2f00-4232-9027-1a5f3540ed4d"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("3e2325ed-32e1-41e3-9f8e-9373c8021bb1"));

            migrationBuilder.DeleteData(
                table: "Employees",
                keyColumn: "Id",
                keyValue: new Guid("7a5dc5a3-35db-48d5-91b7-ae7fd611bd0f"));

            migrationBuilder.DropColumn(
                name: "Country",
                table: "Companies");

            migrationBuilder.DropColumn(
                name: "Industry",
                table: "Companies");

            migrationBuilder.DropColumn(
                name: "Product",
                table: "Companies");

            migrationBuilder.InsertData(
                table: "Companies",
                columns: new[] { "Id", "Introduction", "Name" },
                values: new object[,]
                {
                    { new Guid("01734449-d08e-4447-840b-20b53b8a465c"), "微软的公司简介", "微软公司" },
                    { new Guid("3b53f4c2-d427-4006-b9bd-d77ab568f2b0"), "桃子的公司简介", "桃子" },
                    { new Guid("a423c03a-c623-46a0-8c8b-bff902285f1d"), "葡萄的公司简介", "葡萄" },
                    { new Guid("92288368-424c-4304-aa49-9604c0733b70"), "橙子的公司简介", "橙子" },
                    { new Guid("02221a93-11e2-4d00-9828-f540955a1cf5"), "香蕉的公司简介", "雪梨" },
                    { new Guid("9c3a4eb2-36b4-43ea-af42-e9b845754650"), "香蕉的公司简介", "香蕉" },
                    { new Guid("31df7d18-ee4c-4720-9b77-1c24f0c6e63d"), "Vivo的公司简介", "Vivo" },
                    { new Guid("36cfde7f-35a8-4792-98d7-147779c37d43"), "苹果的公司简介", "苹果" },
                    { new Guid("6369ab09-7f98-4d60-a8be-d4e3e12cd9c2"), "魅族的公司简介", "魅族" },
                    { new Guid("c94da200-36d9-43ce-8639-f23555503a8d"), "三星的公司简介", "三星" },
                    { new Guid("d6ebca99-b540-4c78-9f11-6079e649a665"), "小米的公司简介", "小米" },
                    { new Guid("ba097ba1-b139-4a87-9ded-b43d58231f23"), "HuaWei的公司简介", "华为" },
                    { new Guid("8d4e771d-fe72-482d-b30f-99c0f4c1bf59"), "BiliBili的公司简介", "BiliBili" },
                    { new Guid("5f0d4e0f-1e07-46e0-b551-63fc3eca24ce"), "谷歌的公司简介", "Google" },
                    { new Guid("81cc449c-3d5f-4363-a3fe-8c774bc690eb"), "oppo的公司简介", "oppo" }
                });

            migrationBuilder.InsertData(
                table: "Employees",
                columns: new[] { "Id", "CompanyId", "DateOfBirth", "EmployeeNo", "FistName", "Gender", "LastName" },
                values: new object[,]
                {
                    { new Guid("cd20655e-a363-4805-a4ce-a6cf4b4ae9a2"), new Guid("9e48c982-c52b-46d9-bc9c-d98da8fee770"), new DateTime(2020, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "小", 2, "Lu" },
                    { new Guid("5183c983-e1f0-45f9-b71d-0625de98fff2"), new Guid("7cad215a-131c-4d7b-9167-c9a755143425"), new DateTime(2020, 8, 10, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "张", 1, "三" },
                    { new Guid("9a0e8cb8-e4c6-4fa3-ac91-3467ab4020bd"), new Guid("7cad215a-131c-4d7b-9167-c9a755143425"), new DateTime(2020, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "李", 1, "四" },
                    { new Guid("581c5b45-3ad6-4ece-b04f-247bea17e96e"), new Guid("ac83f843-9cd2-449e-a5f6-656229c617d5"), new DateTime(2020, 8, 29, 0, 0, 0, 0, DateTimeKind.Unspecified), "G003", "小", 1, "江" }
                });
        }
    }
}
